create external table jms_dm.dm_lmdm_three_segment_map_dt (
   is_refund bigint comment '是否退件,1是，0否',
   pick_network_code string comment '寄件网点code',
   pick_network_name string comment '寄件网点名称',
   sign_finance_code string comment '签收财务网点编码',
   sign_finance_name string comment '签收财务网点名称',
   sign_network_code string comment '签收网点code',
   sign_network_name string comment '签收网点名称',
   sign_time timestamp comment '签收时间',
   waybill_no string comment '运单号',
   sj_first_code string comment '实际1段码    ',
   sj_second_code string comment '实际2段码',
   sj_third_code string comment '实际3段码    ',
   dispatch_staff_code string comment '派件业务员code',
   dispatch_staff_name string comment '派件业务员名称',
   receiver_province_id string comment   '收件省份id',
   receiver_province_name string comment   '收件省份名称',
   receiver_city_id string comment   '收件城市id',
   receiver_city_name string comment   '收件城市名称',
   receiver_area_id string comment   '收件区域id',
   receiver_area_name string comment   '收件区域名称',
   receiver_township string comment   '收件乡镇',
   receiver_street string comment   '收件街道',
   receiver_detailed_address string comment   '收件详细地址',
   date_time string comment 'dt'
) COMMENT '地图分单配置表'
PARTITIONED BY (dt STRING COMMENT '签收时间')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_lmdm_three_segment_map_dt'
TBLPROPERTIES (
'discover.partitions'='false',
'parquet.column.index.access'='true'
);